/home/jessie/anaconda3/envs/gov_env/lib/python3.7/site-packages/geopandas/plotting.py:642: UserWarning: Only specify one of 'column' or 'color'. Using 'color'. "Only specify one of 'column' or 'color'. Using 'color'.", UserWarning
| index | nombrearchivo | secuencia | consecutivo | codigoruta | descripcion | longitud | latitud | passuben | pasbajan | fecha | horaregistro | velocidad | recorridoexito | file | año | mes | dia_semana | intervalo_2h | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 8909045981SLP20929082023065258 | 492016943 | 1 | 9208 | Caldas-oriental-variante | -75.632271 | 6.062424 | 1 | 1 | 2023-08-29 | 1900-01-01 06:52:58 | 7.0 | True | Consulta EAFIT-Agosto 29 2023-AMVA.txt | 2023 | 8 | 1 | 1900-01-01 06:00:00 |
| 1 | 1 | 8909045981SLP20929082023065258 | 492016943 | 2 | 9208 | Caldas-oriental-variante | -75.633476 | 6.064199 | 0 | 0 | 2023-08-29 | 1900-01-01 06:53:28 | 37.0 | True | Consulta EAFIT-Agosto 29 2023-AMVA.txt | 2023 | 8 | 1 | 1900-01-01 06:00:00 |
| 2 | 2 | 8909045981SLP20929082023065258 | 492016943 | 3 | 9208 | Caldas-oriental-variante | -75.633568 | 6.066525 | 0 | 0 | 2023-08-29 | 1900-01-01 06:53:52 | 36.0 | True | Consulta EAFIT-Agosto 29 2023-AMVA.txt | 2023 | 8 | 1 | 1900-01-01 06:00:00 |
| 3 | 3 | 8909045981SLP20929082023065258 | 492016943 | 4 | 9208 | Caldas-oriental-variante | -75.633308 | 6.068563 | 0 | 0 | 2023-08-29 | 1900-01-01 06:54:19 | 32.0 | True | Consulta EAFIT-Agosto 29 2023-AMVA.txt | 2023 | 8 | 1 | 1900-01-01 06:00:00 |
| 4 | 4 | 8909045981SLP20929082023065258 | 492016943 | 5 | 9208 | Caldas-oriental-variante | -75.634804 | 6.068773 | 0 | 0 | 2023-08-29 | 1900-01-01 06:54:48 | 0.0 | True | Consulta EAFIT-Agosto 29 2023-AMVA.txt | 2023 | 8 | 1 | 1900-01-01 06:00:00 |
| hora | promedio pasajeros suben | |
|---|---|---|
| 0 | 00:00:00 | 2.058140 |
| 1 | 01:00:00 | 1.898305 |
| 2 | 02:00:00 | 4.295455 |
| 3 | 03:00:00 | 27.516484 |
| 4 | 04:00:00 | 102.539474 |
| 5 | 05:00:00 | 206.253906 |
| 6 | 06:00:00 | 214.007722 |
| 7 | 07:00:00 | 149.579151 |
| 8 | 08:00:00 | 124.024291 |
| 9 | 09:00:00 | 112.549180 |
| 10 | 10:00:00 | 100.779661 |
| 11 | 11:00:00 | 105.541667 |
| 12 | 12:00:00 | 130.308017 |
| 13 | 13:00:00 | 114.282787 |
| 14 | 14:00:00 | 129.485944 |
| 15 | 15:00:00 | 144.447154 |
| 16 | 16:00:00 | 172.603239 |
| 17 | 17:00:00 | 198.059761 |
| 18 | 18:00:00 | 131.428571 |
| 19 | 19:00:00 | 84.991701 |
| 20 | 20:00:00 | 62.129707 |
| 21 | 21:00:00 | 42.410138 |
| 22 | 22:00:00 | 17.463158 |
| 23 | 23:00:00 | 3.760563 |
| hora | promedio pasajeros bajan | |
|---|---|---|
| 0 | 00:00:00 | 0.906977 |
| 1 | 01:00:00 | 0.711864 |
| 2 | 02:00:00 | 6.022727 |
| 3 | 03:00:00 | 28.307692 |
| 4 | 04:00:00 | 87.561404 |
| 5 | 05:00:00 | 158.949219 |
| 6 | 06:00:00 | 200.594595 |
| 7 | 07:00:00 | 150.482625 |
| 8 | 08:00:00 | 126.688259 |
| 9 | 09:00:00 | 120.778689 |
| 10 | 10:00:00 | 104.385593 |
| 11 | 11:00:00 | 109.020833 |
| 12 | 12:00:00 | 140.675105 |
| 13 | 13:00:00 | 116.950820 |
| 14 | 14:00:00 | 135.991968 |
| 15 | 15:00:00 | 136.300813 |
| 16 | 16:00:00 | 152.526316 |
| 17 | 17:00:00 | 170.525896 |
| 18 | 18:00:00 | 140.710204 |
| 19 | 19:00:00 | 94.958506 |
| 20 | 20:00:00 | 65.803347 |
| 21 | 21:00:00 | 48.764977 |
| 22 | 22:00:00 | 25.594737 |
| 23 | 23:00:00 | 6.169014 |
/home/jessie/anaconda3/envs/gov_env/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
| hora | velocidad promedio | |
|---|---|---|
| 0 | 00:00:00 | 0.997949 |
| 1 | 01:00:00 | 0.715278 |
| 2 | 02:00:00 | 1.648496 |
| 3 | 03:00:00 | 14.712795 |
| 4 | 04:00:00 | 15.200796 |
| 5 | 05:00:00 | 14.944174 |
| 6 | 06:00:00 | 13.263298 |
| 7 | 07:00:00 | 12.524719 |
| 8 | 08:00:00 | 12.693699 |
| 9 | 09:00:00 | 12.956647 |
| 10 | 10:00:00 | 13.018310 |
| 11 | 11:00:00 | 12.714390 |
| 12 | 12:00:00 | 12.353168 |
| 13 | 13:00:00 | 12.494748 |
| 14 | 14:00:00 | 11.961499 |
| 15 | 15:00:00 | 12.076293 |
| 16 | 16:00:00 | 11.207921 |
| 17 | 17:00:00 | 11.047652 |
| 18 | 18:00:00 | 12.126405 |
| 19 | 19:00:00 | 13.470684 |
| 20 | 20:00:00 | 14.277995 |
| 21 | 21:00:00 | 14.712949 |
| 22 | 22:00:00 | 15.679667 |
| 23 | 23:00:00 | 12.275390 |